﻿--添加字段操作人字段
alter table wt_reg add fd_nj_clear_date date;
alter table wt_reg add fl_nj_clear_date date;

go

update wt_reg set fd_nj_clear_date = '2020-03-01', fl_nj_clear_date = '2020-01-01'

go

INSERT INTO bd_nianjia(user_serial)
select user_serial from dt_user where user_serial not in (select user_serial from bd_nianjia)
go

UPDATE bd_nianjia set txsx = 7200
go


